{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "data = pd.read_csv('job_data_clean_price.csv')\n",
    "# print(data)\n",
    "# print(data['company_city'].value_counts())\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['上海', '北京', '南京', '天津', '广州', '成都', '杭州', '武汉', '深圳', '苏州', '西安', '重庆']\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"35196124bb984982a5a9bda90126083c\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_35196124bb984982a5a9bda90126083c = echarts.init(document.getElementById('35196124bb984982a5a9bda90126083c'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_35196124bb984982a5a9bda90126083c = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\\u53d1\\u8fbe\\u57ce\\u5e02\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 8936209,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u57ce\\u5e02\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                19966.760412391173,\n",
       "                21469.265071926966,\n",
       "                14443.305693436252,\n",
       "                10334.084784101768,\n",
       "                14442.232804288553,\n",
       "                12524.766308372882,\n",
       "                20086.623178052727,\n",
       "                12060.172553636836,\n",
       "                20112.228044796386,\n",
       "                12707.024443880575,\n",
       "                11679.22482506283,\n",
       "                9909.022390320246\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 8936209\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u57ce\\u5e02\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                14797.654483980648,\n",
       "                15770.024353955221,\n",
       "                10785.755490520498,\n",
       "                8011.990862398474,\n",
       "                10892.897335645399,\n",
       "                9485.559658920321,\n",
       "                14782.811862933051,\n",
       "                9153.448979591847,\n",
       "                14858.160893637374,\n",
       "                9646.521122453632,\n",
       "                8924.101907061557,\n",
       "                7711.189690860438\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 8936209\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u57ce\\u5e02\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                25135.866340801684,\n",
       "                27168.505789898703,\n",
       "                18100.855896351994,\n",
       "                12656.178705805067,\n",
       "                17991.568272931694,\n",
       "                15563.972957825426,\n",
       "                25390.434493172426,\n",
       "                14966.896127681857,\n",
       "                25366.295195955383,\n",
       "                15767.527765307526,\n",
       "                14434.3477430641,\n",
       "                12106.85508978005\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 8936209\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5404\\u57ce\\u5e02\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u57ce\\u5e02\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u57ce\\u5e02\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u4e0a\\u6d77\",\n",
       "                \"\\u5317\\u4eac\",\n",
       "                \"\\u5357\\u4eac\",\n",
       "                \"\\u5929\\u6d25\",\n",
       "                \"\\u5e7f\\u5dde\",\n",
       "                \"\\u6210\\u90fd\",\n",
       "                \"\\u676d\\u5dde\",\n",
       "                \"\\u6b66\\u6c49\",\n",
       "                \"\\u6df1\\u5733\",\n",
       "                \"\\u82cf\\u5dde\",\n",
       "                \"\\u897f\\u5b89\",\n",
       "                \"\\u91cd\\u5e86\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_35196124bb984982a5a9bda90126083c.setOption(option_35196124bb984982a5a9bda90126083c);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"35196124bb984982a5a9bda90126083c\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_35196124bb984982a5a9bda90126083c = echarts.init(document.getElementById('35196124bb984982a5a9bda90126083c'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_35196124bb984982a5a9bda90126083c = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\\u53d1\\u8fbe\\u57ce\\u5e02\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 8936209,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u57ce\\u5e02\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                19966.760412391173,\n",
       "                21469.265071926966,\n",
       "                14443.305693436252,\n",
       "                10334.084784101768,\n",
       "                14442.232804288553,\n",
       "                12524.766308372882,\n",
       "                20086.623178052727,\n",
       "                12060.172553636836,\n",
       "                20112.228044796386,\n",
       "                12707.024443880575,\n",
       "                11679.22482506283,\n",
       "                9909.022390320246\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 8936209\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u57ce\\u5e02\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                14797.654483980648,\n",
       "                15770.024353955221,\n",
       "                10785.755490520498,\n",
       "                8011.990862398474,\n",
       "                10892.897335645399,\n",
       "                9485.559658920321,\n",
       "                14782.811862933051,\n",
       "                9153.448979591847,\n",
       "                14858.160893637374,\n",
       "                9646.521122453632,\n",
       "                8924.101907061557,\n",
       "                7711.189690860438\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 8936209\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u57ce\\u5e02\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                25135.866340801684,\n",
       "                27168.505789898703,\n",
       "                18100.855896351994,\n",
       "                12656.178705805067,\n",
       "                17991.568272931694,\n",
       "                15563.972957825426,\n",
       "                25390.434493172426,\n",
       "                14966.896127681857,\n",
       "                25366.295195955383,\n",
       "                15767.527765307526,\n",
       "                14434.3477430641,\n",
       "                12106.85508978005\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 8936209\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5404\\u57ce\\u5e02\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u57ce\\u5e02\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u57ce\\u5e02\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u4e0a\\u6d77\",\n",
       "                \"\\u5317\\u4eac\",\n",
       "                \"\\u5357\\u4eac\",\n",
       "                \"\\u5929\\u6d25\",\n",
       "                \"\\u5e7f\\u5dde\",\n",
       "                \"\\u6210\\u90fd\",\n",
       "                \"\\u676d\\u5dde\",\n",
       "                \"\\u6b66\\u6c49\",\n",
       "                \"\\u6df1\\u5733\",\n",
       "                \"\\u82cf\\u5dde\",\n",
       "                \"\\u897f\\u5b89\",\n",
       "                \"\\u91cd\\u5e86\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_35196124bb984982a5a9bda90126083c.setOption(option_35196124bb984982a5a9bda90126083c);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from  pyecharts import Bar\n",
    "average_salary = data.groupby('company_city')['job_ave_salary'].mean()#平均工资\n",
    "average_low_salary = data.groupby('company_city')['job_low_salary'].mean()#最低平均工资\n",
    "average_high_salary = data.groupby('company_city')['job_high_salary'].mean()#最高平均工资\n",
    "x = average_salary.reset_index()['company_city'].tolist()\n",
    "y1 = average_salary.reset_index()['job_ave_salary'].tolist()\n",
    "y2 = average_low_salary.reset_index()['job_low_salary'].tolist()\n",
    "y3 = average_high_salary.reset_index()['job_high_salary'].tolist()\n",
    "print(x)\n",
    "\n",
    "bar = Bar(title = \"互联网行业发达城市平均工资\",width = 1000)\n",
    "bar.add(name = \"各城市平均工资\", x_axis = x, y_axis = y1)\n",
    "bar.add(name = \"各城市最低平均工资\", x_axis = x, y_axis = y2,is_xaxis_boundarygap =True)\n",
    "bar.add(name = \"各城市最高平均工资\", x_axis = x, y_axis = y3,is_xaxis_boundarygap =True)\n",
    "\n",
    "# 导出绘图html文件，可直接用浏览器打开\n",
    "bar.render('各城市工资.html')\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Android', 'Java', 'PHP', 'Web前端', 'iOS', '人工智能', '数据分析', '数据挖掘', '数据架构师', '算法工程师']\n[12482.396688128047, 12280.67863715318, 10826.65514193511, 11330.82936870874, 13323.892332738478, 25804.770768920625, 11705.613089984112, 24176.99810256271, 30838.55430284002, 22957.45688598691]\n[9584.0468087897, 9382.698200533578, 8399.264846551912, 8740.84810683685, 10207.144359913593, 18734.71869083087, 8917.369689384155, 17479.105444625406, 23028.302055087766, 16611.67506938844]\n[15380.746567466344, 15178.659073772764, 13254.045437318304, 13920.810630580634, 16440.640305563356, 32874.82284701038, 14493.856490584061, 30874.890760500002, 38648.806550592264, 29303.238702585455]\n"
     ]
    },
    {
     "ename": "NameError",
     "evalue": "name 'Bar' is not defined",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-2-56093335c67d>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m     12\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     13\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 14\u001b[0;31m \u001b[0mbar\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mBar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtitle\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"互联网各行业平均工资\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mwidth\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m1000\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     15\u001b[0m \u001b[0mbar\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0madd\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mname\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"各岗位平均工资\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mx_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0my1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     16\u001b[0m \u001b[0mbar\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0madd\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mname\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"各岗位最低平均工资\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mx_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0my2\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mis_xaxis_boundarygap\u001b[0m \u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mNameError\u001b[0m: name 'Bar' is not defined"
     ],
     "output_type": "error"
    }
   ],
   "source": [
    "job_average_salary = data.groupby('job_type')['job_ave_salary'].mean()#平均工资\n",
    "job_average_low_salary = data.groupby('job_type')['job_low_salary'].mean()#最低平均工资\n",
    "job_average_high_salary = data.groupby('job_type')['job_high_salary'].mean()#最高平均工资\n",
    "x = job_average_salary.reset_index()['job_type'].tolist()\n",
    "print(x)\n",
    "y1 = job_average_salary.reset_index()['job_ave_salary'].tolist()\n",
    "print(y1)\n",
    "y2 = job_average_low_salary.reset_index()['job_low_salary'].tolist()\n",
    "print(y2)\n",
    "y3 = job_average_high_salary.reset_index()['job_high_salary'].tolist()\n",
    "print(y3)\n",
    "\n",
    "\n",
    "bar = Bar(title = \"互联网各行业平均工资\",width = 1000)\n",
    "bar.add(name = \"各岗位平均工资\", x_axis = x, y_axis = y1)\n",
    "bar.add(name = \"各岗位最低平均工资\", x_axis = x, y_axis = y2,is_xaxis_boundarygap =True)\n",
    "bar.add(name = \"各岗位最高平均工资\", x_axis = x, y_axis = y3,is_xaxis_boundarygap =True)\n",
    "\n",
    "# 导出绘图html文件，可直接用浏览器打开\n",
    "bar.render('各岗位工资.html')\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['博士', '大专', '学历不限', '本科', '硕士']\n[41526.45107095235, 10234.00298267229, 13285.769913565966, 16297.385476455183, 26040.220515207646]\n[31508.23020401027, 8018.453158770246, 9996.047008547006, 12144.87269243664, 18781.725091920587]\n[51544.67193789445, 12449.552806574298, 16575.492818584924, 20449.89826047387, 33298.71593849472]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"e4f812b061d44904a059991cf2b18a1d\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_e4f812b061d44904a059991cf2b18a1d = echarts.init(document.getElementById('e4f812b061d44904a059991cf2b18a1d'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_e4f812b061d44904a059991cf2b18a1d = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\\u5404\\u4e2a\\u5b66\\u5386\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2572019,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u5b66\\u5386\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                41526.45107095235,\n",
       "                10234.00298267229,\n",
       "                13285.769913565966,\n",
       "                16297.385476455183,\n",
       "                26040.220515207646\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2572019\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u5b66\\u5386\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                31508.23020401027,\n",
       "                8018.453158770246,\n",
       "                9996.047008547006,\n",
       "                12144.87269243664,\n",
       "                18781.725091920587\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2572019\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u5b66\\u5386\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                51544.67193789445,\n",
       "                12449.552806574298,\n",
       "                16575.492818584924,\n",
       "                20449.89826047387,\n",
       "                33298.71593849472\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2572019\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5404\\u5b66\\u5386\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u5b66\\u5386\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u5b66\\u5386\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u535a\\u58eb\",\n",
       "                \"\\u5927\\u4e13\",\n",
       "                \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                \"\\u672c\\u79d1\",\n",
       "                \"\\u7855\\u58eb\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_e4f812b061d44904a059991cf2b18a1d.setOption(option_e4f812b061d44904a059991cf2b18a1d);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"e4f812b061d44904a059991cf2b18a1d\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_e4f812b061d44904a059991cf2b18a1d = echarts.init(document.getElementById('e4f812b061d44904a059991cf2b18a1d'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_e4f812b061d44904a059991cf2b18a1d = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\\u5404\\u4e2a\\u5b66\\u5386\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2572019,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u5b66\\u5386\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                41526.45107095235,\n",
       "                10234.00298267229,\n",
       "                13285.769913565966,\n",
       "                16297.385476455183,\n",
       "                26040.220515207646\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2572019\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u5b66\\u5386\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                31508.23020401027,\n",
       "                8018.453158770246,\n",
       "                9996.047008547006,\n",
       "                12144.87269243664,\n",
       "                18781.725091920587\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2572019\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5404\\u5b66\\u5386\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                51544.67193789445,\n",
       "                12449.552806574298,\n",
       "                16575.492818584924,\n",
       "                20449.89826047387,\n",
       "                33298.71593849472\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2572019\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5404\\u5b66\\u5386\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u5b66\\u5386\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u5404\\u5b66\\u5386\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u535a\\u58eb\",\n",
       "                \"\\u5927\\u4e13\",\n",
       "                \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                \"\\u672c\\u79d1\",\n",
       "                \"\\u7855\\u58eb\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_e4f812b061d44904a059991cf2b18a1d.setOption(option_e4f812b061d44904a059991cf2b18a1d);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "job_education_average_salary = data.groupby('job_education')['job_ave_salary'].mean()#平均工资\n",
    "job_education_average_low_salary = data.groupby('job_education')['job_low_salary'].mean()#最低平均工资\n",
    "job_education_average_high_salary = data.groupby('job_education')['job_high_salary'].mean()#最高平均工资\n",
    "x = job_education_average_salary.reset_index()['job_education'].tolist()\n",
    "print(x)\n",
    "y1 = job_education_average_salary.reset_index()['job_ave_salary'].tolist()\n",
    "print(y1)\n",
    "y2 = job_education_average_low_salary.reset_index()['job_low_salary'].tolist()\n",
    "print(y2)\n",
    "y3 = job_education_average_high_salary.reset_index()['job_high_salary'].tolist()\n",
    "print(y3)\n",
    "\n",
    "\n",
    "bar = Bar(title = \"互联网行业各个学历平均工资\",width = 1000)\n",
    "bar.add(name = \"各学历平均工资\", x_axis = x, y_axis = y1)\n",
    "bar.add(name = \"各学历最低平均工资\", x_axis = x, y_axis = y2,is_xaxis_boundarygap =True)\n",
    "bar.add(name = \"各学历最高平均工资\", x_axis = x, y_axis = y3,is_xaxis_boundarygap =True)\n",
    "\n",
    "# 导出绘图html文件，可直接用浏览器打开\n",
    "bar.render('各学历工资.html')\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['1-3年', '1年以内', '3-5年', '5-10年', '应届生', '经验不限']\n[13200.912470838939, 10945.060027331354, 18270.841386062377, 27661.853860314164, 11533.416548872989, 17386.01211272294]\n[10008.15516235327, 8261.56443761788, 13596.843854834546, 20588.648781306525, 8871.216542793305, 12695.011131022386]\n[16393.669779324642, 13628.555617044829, 22944.83891729017, 34735.05893932176, 14195.616554952649, 22077.01309442354]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"9a5cb3a3164a4813a846bc9ad6d74f86\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_9a5cb3a3164a4813a846bc9ad6d74f86 = echarts.init(document.getElementById('9a5cb3a3164a4813a846bc9ad6d74f86'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_9a5cb3a3164a4813a846bc9ad6d74f86 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2408436,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                13200.912470838939,\n",
       "                10945.060027331354,\n",
       "                18270.841386062377,\n",
       "                27661.853860314164,\n",
       "                11533.416548872989,\n",
       "                17386.01211272294\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2408436\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                10008.15516235327,\n",
       "                8261.56443761788,\n",
       "                13596.843854834546,\n",
       "                20588.648781306525,\n",
       "                8871.216542793305,\n",
       "                12695.011131022386\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2408436\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                16393.669779324642,\n",
       "                13628.555617044829,\n",
       "                22944.83891729017,\n",
       "                34735.05893932176,\n",
       "                14195.616554952649,\n",
       "                22077.01309442354\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2408436\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"1-3\\u5e74\",\n",
       "                \"1\\u5e74\\u4ee5\\u5185\",\n",
       "                \"3-5\\u5e74\",\n",
       "                \"5-10\\u5e74\",\n",
       "                \"\\u5e94\\u5c4a\\u751f\",\n",
       "                \"\\u7ecf\\u9a8c\\u4e0d\\u9650\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_9a5cb3a3164a4813a846bc9ad6d74f86.setOption(option_9a5cb3a3164a4813a846bc9ad6d74f86);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"9a5cb3a3164a4813a846bc9ad6d74f86\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_9a5cb3a3164a4813a846bc9ad6d74f86 = echarts.init(document.getElementById('9a5cb3a3164a4813a846bc9ad6d74f86'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_9a5cb3a3164a4813a846bc9ad6d74f86 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2408436,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                13200.912470838939,\n",
       "                10945.060027331354,\n",
       "                18270.841386062377,\n",
       "                27661.853860314164,\n",
       "                11533.416548872989,\n",
       "                17386.01211272294\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2408436\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                10008.15516235327,\n",
       "                8261.56443761788,\n",
       "                13596.843854834546,\n",
       "                20588.648781306525,\n",
       "                8871.216542793305,\n",
       "                12695.011131022386\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2408436\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "            \"data\": [\n",
       "                16393.669779324642,\n",
       "                13628.555617044829,\n",
       "                22944.83891729017,\n",
       "                34735.05893932176,\n",
       "                14195.616554952649,\n",
       "                22077.01309442354\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2408436\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\",\n",
       "                \"\\u4e0d\\u540c\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"1-3\\u5e74\",\n",
       "                \"1\\u5e74\\u4ee5\\u5185\",\n",
       "                \"3-5\\u5e74\",\n",
       "                \"5-10\\u5e74\",\n",
       "                \"\\u5e94\\u5c4a\\u751f\",\n",
       "                \"\\u7ecf\\u9a8c\\u4e0d\\u9650\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_9a5cb3a3164a4813a846bc9ad6d74f86.setOption(option_9a5cb3a3164a4813a846bc9ad6d74f86);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "job_experience_average_salary = data.groupby('job_experience')['job_ave_salary'].mean()#平均工资\n",
    "job_experience_average_low_salary = data.groupby('job_experience')['job_low_salary'].mean()#最低平均工资\n",
    "job_experience_average_high_salary = data.groupby('job_experience')['job_high_salary'].mean()#最高平均工资\n",
    "x = job_experience_average_salary.reset_index()['job_experience'].tolist()\n",
    "print(x)\n",
    "y1 = job_experience_average_salary.reset_index()['job_ave_salary'].tolist()\n",
    "print(y1)\n",
    "y2 = job_experience_average_low_salary.reset_index()['job_low_salary'].tolist()\n",
    "print(y2)\n",
    "y3 = job_experience_average_high_salary.reset_index()['job_high_salary'].tolist()\n",
    "print(y3)\n",
    "\n",
    "\n",
    "bar = Bar(title = \"互联网行业不同工作经验平均工资\",width = 1000)\n",
    "bar.add(name = \"不同工作经验平均工资\", x_axis = x, y_axis = y1)\n",
    "bar.add(name = \"不同工作经验最低平均工资\", x_axis = x, y_axis = y2,is_xaxis_boundarygap =True)\n",
    "bar.add(name = \"不同工作经验最高平均工资\", x_axis = x, y_axis = y3,is_xaxis_boundarygap =True)\n",
    "\n",
    "# 导出绘图html文件，可直接用浏览器打开\n",
    "bar.render('不同工作经验工资.html')\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['1-3年', '1年以内', '3-5年', '5-10年', '应届生', '经验不限']\n[11578, 973, 7660, 1511, 723, 5668]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"4c04e3f08baa4aff84618df6229f1456\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_4c04e3f08baa4aff84618df6229f1456 = echarts.init(document.getElementById('4c04e3f08baa4aff84618df6229f1456'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_4c04e3f08baa4aff84618df6229f1456 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u8981\\u6c42\\u5360\\u6bd4\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 3626813,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"1-3\\u5e74\",\n",
       "                    \"value\": 11578\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"1\\u5e74\\u4ee5\\u5185\",\n",
       "                    \"value\": 973\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"3-5\\u5e74\",\n",
       "                    \"value\": 7660\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"5-10\\u5e74\",\n",
       "                    \"value\": 1511\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e94\\u5c4a\\u751f\",\n",
       "                    \"value\": 723\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7ecf\\u9a8c\\u4e0d\\u9650\",\n",
       "                    \"value\": 5668\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 3626813\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"1-3\\u5e74\",\n",
       "                \"1\\u5e74\\u4ee5\\u5185\",\n",
       "                \"3-5\\u5e74\",\n",
       "                \"5-10\\u5e74\",\n",
       "                \"\\u5e94\\u5c4a\\u751f\",\n",
       "                \"\\u7ecf\\u9a8c\\u4e0d\\u9650\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_4c04e3f08baa4aff84618df6229f1456.setOption(option_4c04e3f08baa4aff84618df6229f1456);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"4c04e3f08baa4aff84618df6229f1456\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_4c04e3f08baa4aff84618df6229f1456 = echarts.init(document.getElementById('4c04e3f08baa4aff84618df6229f1456'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_4c04e3f08baa4aff84618df6229f1456 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5de5\\u4f5c\\u7ecf\\u9a8c\\u8981\\u6c42\\u5360\\u6bd4\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 3626813,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"1-3\\u5e74\",\n",
       "                    \"value\": 11578\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"1\\u5e74\\u4ee5\\u5185\",\n",
       "                    \"value\": 973\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"3-5\\u5e74\",\n",
       "                    \"value\": 7660\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"5-10\\u5e74\",\n",
       "                    \"value\": 1511\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e94\\u5c4a\\u751f\",\n",
       "                    \"value\": 723\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7ecf\\u9a8c\\u4e0d\\u9650\",\n",
       "                    \"value\": 5668\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 3626813\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"1-3\\u5e74\",\n",
       "                \"1\\u5e74\\u4ee5\\u5185\",\n",
       "                \"3-5\\u5e74\",\n",
       "                \"5-10\\u5e74\",\n",
       "                \"\\u5e94\\u5c4a\\u751f\",\n",
       "                \"\\u7ecf\\u9a8c\\u4e0d\\u9650\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_4c04e3f08baa4aff84618df6229f1456.setOption(option_4c04e3f08baa4aff84618df6229f1456);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Pie\n",
    "experience_count = data.groupby('job_experience')['job_ave_salary'].count()#平均工资\n",
    "print(experience_count.reset_index()['job_experience'].tolist())\n",
    "print(experience_count.reset_index()['job_ave_salary'].tolist())\n",
    "attr = experience_count.reset_index()['job_experience'].tolist()\n",
    "value = experience_count.reset_index()['job_ave_salary'].tolist()\n",
    "\n",
    "# 初始化图表通用属性\n",
    "pie = Pie(title = \"工作经验要求占比\",\n",
    "          title_pos = 'center', # 标题居中\n",
    "          title_top = 'bottom', # 标题在底部\n",
    "          title_color = '#0000ff', # 标题颜色设置为蓝色，256位rgb格式\n",
    "          background_color = \"#aee\", # 设置背景颜色，16位rgb格式\n",
    "          width = 600,height = 420)\n",
    "\n",
    "pie.add(\"\", attr, value, is_label_show=True)\n",
    "pie.render('各个工作经验要求占比.html')\n",
    "pie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['博士', '大专', '学历不限', '本科', '硕士']\n[207, 5298, 1368, 18440, 2744]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"e61ab945d0c74c058f05f46cf3181513\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_e61ab945d0c74c058f05f46cf3181513 = echarts.init(document.getElementById('e61ab945d0c74c058f05f46cf3181513'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_e61ab945d0c74c058f05f46cf3181513 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5b66\\u5386\\u8981\\u6c42\\u5360\\u6bd4\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2070020,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u535a\\u58eb\",\n",
       "                    \"value\": 207\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5927\\u4e13\",\n",
       "                    \"value\": 5298\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                    \"value\": 1368\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u672c\\u79d1\",\n",
       "                    \"value\": 18440\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7855\\u58eb\",\n",
       "                    \"value\": 2744\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 2070020\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u535a\\u58eb\",\n",
       "                \"\\u5927\\u4e13\",\n",
       "                \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                \"\\u672c\\u79d1\",\n",
       "                \"\\u7855\\u58eb\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_e61ab945d0c74c058f05f46cf3181513.setOption(option_e61ab945d0c74c058f05f46cf3181513);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"e61ab945d0c74c058f05f46cf3181513\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_e61ab945d0c74c058f05f46cf3181513 = echarts.init(document.getElementById('e61ab945d0c74c058f05f46cf3181513'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_e61ab945d0c74c058f05f46cf3181513 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5b66\\u5386\\u8981\\u6c42\\u5360\\u6bd4\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2070020,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u535a\\u58eb\",\n",
       "                    \"value\": 207\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5927\\u4e13\",\n",
       "                    \"value\": 5298\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                    \"value\": 1368\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u672c\\u79d1\",\n",
       "                    \"value\": 18440\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7855\\u58eb\",\n",
       "                    \"value\": 2744\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 2070020\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u535a\\u58eb\",\n",
       "                \"\\u5927\\u4e13\",\n",
       "                \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                \"\\u672c\\u79d1\",\n",
       "                \"\\u7855\\u58eb\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_e61ab945d0c74c058f05f46cf3181513.setOption(option_e61ab945d0c74c058f05f46cf3181513);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "experience_count = data.groupby('job_education')['job_ave_salary'].count()#平均工资\n",
    "print(experience_count.reset_index()['job_education'].tolist())\n",
    "print(experience_count.reset_index()['job_ave_salary'].tolist())\n",
    "attr = experience_count.reset_index()['job_education'].tolist()\n",
    "value = experience_count.reset_index()['job_ave_salary'].tolist()\n",
    "\n",
    "# 初始化图表通用属性\n",
    "pie = Pie(title = \"学历要求占比\",\n",
    "          title_pos = 'center', # 标题居中\n",
    "          title_top = 'bottom', # 标题在底部\n",
    "          title_color = '#0000ff', # 标题颜色设置为蓝色，256位rgb格式\n",
    "          background_color = \"#aee\", # 设置背景颜色，16位rgb格式\n",
    "          width = 600,height = 420)\n",
    "\n",
    "pie.add(\"\", attr, value, is_label_show=True)\n",
    "pie.render('学历要求占比.html')\n",
    "pie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "# fr = open(\"job_data_clean_price.csv\", \"r\")\n",
    "# fw = open(\"job_data_count_company.csv\", \"w\")\n",
    "# datas = fr.readlines()\n",
    "# for data in datas:\n",
    "#     list = data.split(\",\")\n",
    "#     if (list[4].find(\"腾讯\") != -1 or list[4].find(\"Tencent\") != -1 or list[4].find(\"tencent\") != -1):\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"腾讯\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"京东\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"京东\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"滴滴\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"滴滴\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"百度\") != -1):\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"百度\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         print(list[4])\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"今日头条\") != -1 or list[4].find(\"字节跳动\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"字节跳动\", list[5], list[6],\n",
    "#                                                      list[7], list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"阿里\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"阿里\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"蚂蚁金服\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"蚂蚁金服\", list[5], list[6],\n",
    "#                                                      list[7], list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"饿了么\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"饿了么\", list[5], list[6],\n",
    "#                                                      list[7], list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"美团\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"美团\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n",
    "#     if (list[4].find(\"华为\") != -1):\n",
    "#         print(list[4])\n",
    "#         fw.write(\n",
    "#             \"{},{},{},{},{},{},{},{},{}\".format(list[0], list[1], list[2], list[3], \"华为\", list[5], list[6], list[7],\n",
    "#                                                 list[8], list[9]))\n",
    "#         fw.write(\"\\n\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['京东', '华为', '字节跳动', '滴滴', '百度', '美团', '腾讯', '蚂蚁金服', '阿里', '饿了么']\n[98, 289, 69, 69, 132, 13, 265, 185, 313, 18]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"306c304cfc6a4e7dac06777dd31017eb\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_306c304cfc6a4e7dac06777dd31017eb = echarts.init(document.getElementById('306c304cfc6a4e7dac06777dd31017eb'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_306c304cfc6a4e7dac06777dd31017eb = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5927\\u5382\\u62db\\u8058\\u6bd4\\u4f8b\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 4091986,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u4eac\\u4e1c\",\n",
       "                    \"value\": 98\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u534e\\u4e3a\",\n",
       "                    \"value\": 289\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                    \"value\": 69\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6ef4\\u6ef4\",\n",
       "                    \"value\": 69\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u767e\\u5ea6\",\n",
       "                    \"value\": 132\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7f8e\\u56e2\",\n",
       "                    \"value\": 13\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u817e\\u8baf\",\n",
       "                    \"value\": 265\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8682\\u8681\\u91d1\\u670d\",\n",
       "                    \"value\": 185\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u963f\\u91cc\",\n",
       "                    \"value\": 313\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u997f\\u4e86\\u4e48\",\n",
       "                    \"value\": 18\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 4091986\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u4eac\\u4e1c\",\n",
       "                \"\\u534e\\u4e3a\",\n",
       "                \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                \"\\u6ef4\\u6ef4\",\n",
       "                \"\\u767e\\u5ea6\",\n",
       "                \"\\u7f8e\\u56e2\",\n",
       "                \"\\u817e\\u8baf\",\n",
       "                \"\\u8682\\u8681\\u91d1\\u670d\",\n",
       "                \"\\u963f\\u91cc\",\n",
       "                \"\\u997f\\u4e86\\u4e48\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_306c304cfc6a4e7dac06777dd31017eb.setOption(option_306c304cfc6a4e7dac06777dd31017eb);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"306c304cfc6a4e7dac06777dd31017eb\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_306c304cfc6a4e7dac06777dd31017eb = echarts.init(document.getElementById('306c304cfc6a4e7dac06777dd31017eb'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_306c304cfc6a4e7dac06777dd31017eb = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5927\\u5382\\u62db\\u8058\\u6bd4\\u4f8b\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 4091986,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u4eac\\u4e1c\",\n",
       "                    \"value\": 98\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u534e\\u4e3a\",\n",
       "                    \"value\": 289\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                    \"value\": 69\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6ef4\\u6ef4\",\n",
       "                    \"value\": 69\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u767e\\u5ea6\",\n",
       "                    \"value\": 132\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7f8e\\u56e2\",\n",
       "                    \"value\": 13\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u817e\\u8baf\",\n",
       "                    \"value\": 265\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8682\\u8681\\u91d1\\u670d\",\n",
       "                    \"value\": 185\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u963f\\u91cc\",\n",
       "                    \"value\": 313\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u997f\\u4e86\\u4e48\",\n",
       "                    \"value\": 18\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 4091986\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u4eac\\u4e1c\",\n",
       "                \"\\u534e\\u4e3a\",\n",
       "                \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                \"\\u6ef4\\u6ef4\",\n",
       "                \"\\u767e\\u5ea6\",\n",
       "                \"\\u7f8e\\u56e2\",\n",
       "                \"\\u817e\\u8baf\",\n",
       "                \"\\u8682\\u8681\\u91d1\\u670d\",\n",
       "                \"\\u963f\\u91cc\",\n",
       "                \"\\u997f\\u4e86\\u4e48\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_306c304cfc6a4e7dac06777dd31017eb.setOption(option_306c304cfc6a4e7dac06777dd31017eb);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_company = pd.read_csv('job_data_count_company.csv')\n",
    "company_count = data_company.groupby('job_company')['job_ave_salary'].count()\n",
    "\n",
    "\n",
    "x = company_count.reset_index()['job_company'].tolist()\n",
    "print(x)\n",
    "y1 = company_count.reset_index()['job_ave_salary'].tolist()\n",
    "print(y1)\n",
    "\n",
    "\n",
    "\n",
    "bar = Bar(title = \"大厂招聘数量\",width = 1000)\n",
    "bar.add(name = \"大厂招聘数量\", x_axis = x, y_axis = y1)\n",
    "bar.render('大厂招聘数量.html')\n",
    "bar\n",
    "\n",
    "# 初始化图表通用属性\n",
    "pie = Pie(title = \"大厂招聘比例\",\n",
    "          title_pos = 'center', # 标题居中\n",
    "          title_top = 'bottom', # 标题在底部\n",
    "          title_color = '#0000ff', # 标题颜色设置为蓝色，256位rgb格式\n",
    "          background_color = \"#aee\", # 设置背景颜色，16位rgb格式\n",
    "          width = 600,height = 420)\n",
    "\n",
    "pie.add(\"\", x, y1, is_label_show=True)\n",
    "pie.render('大厂招聘比例.html')\n",
    "pie\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min', 'china': '/nbextensions/echarts-countries-js/china'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"3710b47cbac34e42b9e0df58e912d470\" style=\"width:600px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts', 'china'], function(echarts) {\n",
       "        \n",
       "var myChart_3710b47cbac34e42b9e0df58e912d470 = echarts.init(document.getElementById('3710b47cbac34e42b9e0df58e912d470'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_3710b47cbac34e42b9e0df58e912d470 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5168\\u56fd\\u7701\\u4efd\\u5730\\u56fe\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 7750818,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"map\",\n",
       "            \"symbol\": \"circle\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"mapType\": \"china\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\",\n",
       "                    \"value\": 3112\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\",\n",
       "                    \"value\": 3370\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5357\\u4eac\",\n",
       "                    \"value\": 2298\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5929\\u6d25\",\n",
       "                    \"value\": 1472\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\",\n",
       "                    \"value\": 2577\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6210\\u90fd\",\n",
       "                    \"value\": 2196\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u676d\\u5dde\",\n",
       "                    \"value\": 3097\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6b66\\u6c49\",\n",
       "                    \"value\": 2100\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6df1\\u5733\",\n",
       "                    \"value\": 3161\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u82cf\\u5dde\",\n",
       "                    \"value\": 1689\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u897f\\u5b89\",\n",
       "                    \"value\": 1784\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u91cd\\u5e86\",\n",
       "                    \"value\": 1306\n",
       "                }\n",
       "            ],\n",
       "            \"roam\": true,\n",
       "            \"showLegendSymbol\": true\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"visualMap\": {\n",
       "        \"type\": \"piecewise\",\n",
       "        \"min\": 0,\n",
       "        \"max\": 100,\n",
       "        \"text\": [\n",
       "            \"\",\n",
       "            \"\"\n",
       "        ],\n",
       "        \"textStyle\": {\n",
       "            \"color\": \"#000\"\n",
       "        },\n",
       "        \"inRange\": {\n",
       "            \"color\": [\n",
       "                \"#50a3ba\",\n",
       "                \"#eac763\",\n",
       "                \"#d94e5d\"\n",
       "            ]\n",
       "        },\n",
       "        \"calculable\": true,\n",
       "        \"splitNumber\": 5,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"left\",\n",
       "        \"top\": \"bottom\",\n",
       "        \"showLabel\": true\n",
       "    }\n",
       "};\n",
       "myChart_3710b47cbac34e42b9e0df58e912d470.setOption(option_3710b47cbac34e42b9e0df58e912d470);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min', 'china': '/nbextensions/echarts-countries-js/china'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"3710b47cbac34e42b9e0df58e912d470\" style=\"width:600px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts', 'china'], function(echarts) {\n",
       "        \n",
       "var myChart_3710b47cbac34e42b9e0df58e912d470 = echarts.init(document.getElementById('3710b47cbac34e42b9e0df58e912d470'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_3710b47cbac34e42b9e0df58e912d470 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5168\\u56fd\\u7701\\u4efd\\u5730\\u56fe\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 7750818,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"map\",\n",
       "            \"symbol\": \"circle\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"mapType\": \"china\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\",\n",
       "                    \"value\": 3112\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\",\n",
       "                    \"value\": 3370\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5357\\u4eac\",\n",
       "                    \"value\": 2298\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5929\\u6d25\",\n",
       "                    \"value\": 1472\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u5dde\",\n",
       "                    \"value\": 2577\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6210\\u90fd\",\n",
       "                    \"value\": 2196\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u676d\\u5dde\",\n",
       "                    \"value\": 3097\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6b66\\u6c49\",\n",
       "                    \"value\": 2100\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6df1\\u5733\",\n",
       "                    \"value\": 3161\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u82cf\\u5dde\",\n",
       "                    \"value\": 1689\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u897f\\u5b89\",\n",
       "                    \"value\": 1784\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u91cd\\u5e86\",\n",
       "                    \"value\": 1306\n",
       "                }\n",
       "            ],\n",
       "            \"roam\": true,\n",
       "            \"showLegendSymbol\": true\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"visualMap\": {\n",
       "        \"type\": \"piecewise\",\n",
       "        \"min\": 0,\n",
       "        \"max\": 100,\n",
       "        \"text\": [\n",
       "            \"\",\n",
       "            \"\"\n",
       "        ],\n",
       "        \"textStyle\": {\n",
       "            \"color\": \"#000\"\n",
       "        },\n",
       "        \"inRange\": {\n",
       "            \"color\": [\n",
       "                \"#50a3ba\",\n",
       "                \"#eac763\",\n",
       "                \"#d94e5d\"\n",
       "            ]\n",
       "        },\n",
       "        \"calculable\": true,\n",
       "        \"splitNumber\": 5,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"left\",\n",
       "        \"top\": \"bottom\",\n",
       "        \"showLabel\": true\n",
       "    }\n",
       "};\n",
       "myChart_3710b47cbac34e42b9e0df58e912d470.setOption(option_3710b47cbac34e42b9e0df58e912d470);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    ""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['京东', '华为', '字节跳动', '滴滴', '百度', '美团', '腾讯', '蚂蚁金服', '阿里', '饿了么']\n[27412.222471406152, 35745.69503872883, 31767.632850241545, 32953.83022774327, 23239.06926406926, 29500.0, 29976.48524431543, 34463.9507154213, 29593.133586015563, 27394.01709401709]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"01aa61dfaf1d4ffeaca82adc35d6f6ad\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_01aa61dfaf1d4ffeaca82adc35d6f6ad = echarts.init(document.getElementById('01aa61dfaf1d4ffeaca82adc35d6f6ad'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_01aa61dfaf1d4ffeaca82adc35d6f6ad = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5927\\u5382\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 382267,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5927\\u5382\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"data\": [\n",
       "                27412.222471406152,\n",
       "                35745.69503872883,\n",
       "                31767.632850241545,\n",
       "                32953.83022774327,\n",
       "                23239.06926406926,\n",
       "                29500.0,\n",
       "                29976.48524431543,\n",
       "                34463.9507154213,\n",
       "                29593.133586015563,\n",
       "                27394.01709401709\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 382267\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5927\\u5382\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"data\": [\n",
       "                19613.568064588468,\n",
       "                26050.307325485428,\n",
       "                21718.840579710144,\n",
       "                23526.708074534163,\n",
       "                17178.78787878788,\n",
       "                20461.53846153846,\n",
       "                20860.196281705717,\n",
       "                24833.777669071787,\n",
       "                20994.35670512536,\n",
       "                19187.820512820515\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 382267\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5927\\u5382\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"data\": [\n",
       "                35210.876878223804,\n",
       "                45441.08275197223,\n",
       "                41816.42512077295,\n",
       "                42380.95238095238,\n",
       "                29299.35064935065,\n",
       "                38538.46153846154,\n",
       "                39092.774206925154,\n",
       "                44094.12376177082,\n",
       "                38191.91046690576,\n",
       "                35600.21367521367\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 382267\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5927\\u5382\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "                \"\\u5927\\u5382\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "                \"\\u5927\\u5382\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u4eac\\u4e1c\",\n",
       "                \"\\u534e\\u4e3a\",\n",
       "                \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                \"\\u6ef4\\u6ef4\",\n",
       "                \"\\u767e\\u5ea6\",\n",
       "                \"\\u7f8e\\u56e2\",\n",
       "                \"\\u817e\\u8baf\",\n",
       "                \"\\u8682\\u8681\\u91d1\\u670d\",\n",
       "                \"\\u963f\\u91cc\",\n",
       "                \"\\u997f\\u4e86\\u4e48\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_01aa61dfaf1d4ffeaca82adc35d6f6ad.setOption(option_01aa61dfaf1d4ffeaca82adc35d6f6ad);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"01aa61dfaf1d4ffeaca82adc35d6f6ad\" style=\"width:1000px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_01aa61dfaf1d4ffeaca82adc35d6f6ad = echarts.init(document.getElementById('01aa61dfaf1d4ffeaca82adc35d6f6ad'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_01aa61dfaf1d4ffeaca82adc35d6f6ad = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5927\\u5382\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 382267,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5927\\u5382\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"data\": [\n",
       "                27412.222471406152,\n",
       "                35745.69503872883,\n",
       "                31767.632850241545,\n",
       "                32953.83022774327,\n",
       "                23239.06926406926,\n",
       "                29500.0,\n",
       "                29976.48524431543,\n",
       "                34463.9507154213,\n",
       "                29593.133586015563,\n",
       "                27394.01709401709\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 382267\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5927\\u5382\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"data\": [\n",
       "                19613.568064588468,\n",
       "                26050.307325485428,\n",
       "                21718.840579710144,\n",
       "                23526.708074534163,\n",
       "                17178.78787878788,\n",
       "                20461.53846153846,\n",
       "                20860.196281705717,\n",
       "                24833.777669071787,\n",
       "                20994.35670512536,\n",
       "                19187.820512820515\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 382267\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u5927\\u5382\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "            \"data\": [\n",
       "                35210.876878223804,\n",
       "                45441.08275197223,\n",
       "                41816.42512077295,\n",
       "                42380.95238095238,\n",
       "                29299.35064935065,\n",
       "                38538.46153846154,\n",
       "                39092.774206925154,\n",
       "                44094.12376177082,\n",
       "                38191.91046690576,\n",
       "                35600.21367521367\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 382267\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5927\\u5382\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "                \"\\u5927\\u5382\\u6700\\u4f4e\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\",\n",
       "                \"\\u5927\\u5382\\u6700\\u9ad8\\u5e73\\u5747\\u5de5\\u8d44\\u5f85\\u9047\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u4eac\\u4e1c\",\n",
       "                \"\\u534e\\u4e3a\",\n",
       "                \"\\u5b57\\u8282\\u8df3\\u52a8\",\n",
       "                \"\\u6ef4\\u6ef4\",\n",
       "                \"\\u767e\\u5ea6\",\n",
       "                \"\\u7f8e\\u56e2\",\n",
       "                \"\\u817e\\u8baf\",\n",
       "                \"\\u8682\\u8681\\u91d1\\u670d\",\n",
       "                \"\\u963f\\u91cc\",\n",
       "                \"\\u997f\\u4e86\\u4e48\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"nameGap\": 25,\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"inverse\": false,\n",
       "            \"boundaryGap\": true,\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_01aa61dfaf1d4ffeaca82adc35d6f6ad.setOption(option_01aa61dfaf1d4ffeaca82adc35d6f6ad);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_company = pd.read_csv('job_data_count_company.csv')\n",
    "company_ave_salary = data_company.groupby('job_company')['job_ave_salary'].mean()\n",
    "company_low_salary = data_company.groupby('job_company')['job_low_salary'].mean()\n",
    "company_high_salary = data_company.groupby('job_company')['job_high_salary'].mean()\n",
    "\n",
    "\n",
    "x = company_ave_salary.reset_index()['job_company'].tolist()\n",
    "print(x)\n",
    "y1 = company_ave_salary.reset_index()['job_ave_salary'].tolist()\n",
    "print(y1)\n",
    "y2 = company_low_salary.reset_index()['job_low_salary'].tolist()\n",
    "y3 = company_high_salary.reset_index()['job_high_salary'].tolist()\n",
    "\n",
    "bar = Bar(title = \"大厂工资待遇\",width = 1000)\n",
    "bar.add(name = \"大厂平均工资待遇\", x_axis = x, y_axis = y1)\n",
    "bar.add(name = \"大厂最低平均工资待遇\", x_axis = x, y_axis = y2,is_xaxis_boundarygap =True)\n",
    "bar.add(name = \"大厂最高平均工资待遇\", x_axis = x, y_axis = y3,is_xaxis_boundarygap =True)\n",
    "\n",
    "bar.render('大厂工资待遇.html')\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['博士', '大专', '学历不限', '本科', '硕士']\n[8, 33, 29, 922, 236]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"f359c11d79404bd999c8d56fd347c220\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_f359c11d79404bd999c8d56fd347c220 = echarts.init(document.getElementById('f359c11d79404bd999c8d56fd347c220'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_f359c11d79404bd999c8d56fd347c220 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u6570\\u636e\\u6316\\u6398\\u5b66\\u5386\\u8981\\u6c42\\u5360\\u6bd4\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2142519,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u535a\\u58eb\",\n",
       "                    \"value\": 8\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5927\\u4e13\",\n",
       "                    \"value\": 33\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                    \"value\": 29\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u672c\\u79d1\",\n",
       "                    \"value\": 922\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7855\\u58eb\",\n",
       "                    \"value\": 236\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 2142519\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u535a\\u58eb\",\n",
       "                \"\\u5927\\u4e13\",\n",
       "                \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                \"\\u672c\\u79d1\",\n",
       "                \"\\u7855\\u58eb\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_f359c11d79404bd999c8d56fd347c220.setOption(option_f359c11d79404bd999c8d56fd347c220);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"f359c11d79404bd999c8d56fd347c220\" style=\"width:600px;height:420px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_f359c11d79404bd999c8d56fd347c220 = echarts.init(document.getElementById('f359c11d79404bd999c8d56fd347c220'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_f359c11d79404bd999c8d56fd347c220 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u6570\\u636e\\u6316\\u6398\\u5b66\\u5386\\u8981\\u6c42\\u5360\\u6bd4\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"bottom\",\n",
       "            \"textStyle\": {\n",
       "                \"color\": \"#0000ff\",\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 2142519,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u535a\\u58eb\",\n",
       "                    \"value\": 8\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5927\\u4e13\",\n",
       "                    \"value\": 33\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                    \"value\": 29\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u672c\\u79d1\",\n",
       "                    \"value\": 922\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7855\\u58eb\",\n",
       "                    \"value\": 236\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"0%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 2142519\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u535a\\u58eb\",\n",
       "                \"\\u5927\\u4e13\",\n",
       "                \"\\u5b66\\u5386\\u4e0d\\u9650\",\n",
       "                \"\\u672c\\u79d1\",\n",
       "                \"\\u7855\\u58eb\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"backgroundColor\": \"#aee\",\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_f359c11d79404bd999c8d56fd347c220.setOption(option_f359c11d79404bd999c8d56fd347c220);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Pie\n",
    "import pandas as pd\n",
    "data = pd.read_csv('job_data_clean_price.csv')\n",
    "\n",
    "experience_count = data.loc[data['job_type']=='数据挖掘'].groupby('job_education').count()#平均工资\n",
    "print(experience_count.reset_index()['job_education'].tolist())\n",
    "print(experience_count.reset_index()['job_ave_salary'].tolist())\n",
    "attr = experience_count.reset_index()['job_education'].tolist()\n",
    "value = experience_count.reset_index()['job_ave_salary'].tolist()\n",
    "# 初始化图表通用属性\n",
    "pie = Pie(title = \"数据挖掘学历要求占比\",\n",
    "          title_pos = 'center', # 标题居中\n",
    "          title_top = 'bottom', # 标题在底部\n",
    "          title_color = '#0000ff', # 标题颜色设置为蓝色，256位rgb格式\n",
    "          background_color = \"#aee\", # 设置背景颜色，16位rgb格式\n",
    "          width = 600,height = 420)\n",
    "\n",
    "\n",
    "pie.add(\"\", attr, value, is_label_show=True)\n",
    "pie.render('数据挖掘学历要求占比.html')\n",
    "pie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}
